Manipulating data with R by Valentina Porcu

Author:Valentina Porcu
Language: eng
Format: azw3
Published: 2017-07-05T04:00:00+00:00

The most important parameters are drv, which represents an object of the MySQLDriver class, or the “MySQL” string, or a MySQLConnection, the name of the dbname database, the host, that is to say, the link where the database is found, the door, username and password.

con <- dbDriver(“MySQL”)

Once logged to the database, we can for instance list the database tables using the following function:

dbListTables(con)

The dbReadTable() function is used to import a table into R:

dbReadTable(con, “nome_tabella”)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.